Description: This is an Excel workbook that can be used as a tool for health insurance companies to model their potential risk exposure from an influenza pandemic. It is based on a model developed for a Society of Actuaries study examining the potential implications of a pandemic on the U.S. health insurance industry. The spreadsheet is saved with many of the same assumptions used in this research and reproduces the results of the exhibits contained in the June 2010 report, 'Potential Impact of Pandemic Influenza on the U.S. Health Insurance Industry.'

Description: Dataset to accompany Fifty States, Fifty Stories: A Decade of Health Care Reform Under the Affordable Care Act - Technical Report

Description: The Society of Actuaries' Pension Section and Health Section Research teams commissioned Professor Thomas E. Getzen of Temple University to construct a resource model for the projection of long term healthcare cost trends. The motivation for creation of the model was driven by its potential usage as a resource for the estimation of reportable liabilities for retiree healthcare benefits as specified under FAS 106 and GASB 45 accounting statements. This model, programmed in Microsoft Excel [xlsx format], projects per-person expenditures and growth rates through 2099 using a set of equations and assumptions developed by Professor Getzen with assistance from the Society of Actuaries Project Oversight Group appointed to oversee the effort. The model includes baseline assumptions as well as flexibility for user–inputted alternative assumptions.

Description: A divisive confrontation over health care pricing is almost inevitable over the next few years. What will ultimately happen is a political decision, not an actuarial one—but it will have major consequences for the trend in health care costs and the divergence between public and private insurance premiums.

Description: The MACRA/QPP Payer Revenue Model is designed to provide Health Plans an estimate of the expected claim cost increase/decrease due to MACRA.

Description: Report to give actuaries practical information and guidance on LTD claim credibility for case level pricing and underwriting.